**************************************************************************************
* Bemærk at denne fil kun er til orientering om databaseændringer til denne release. *
* Filen MÅ IKKE afvikles!                                                            *
**************************************************************************************

IF NOT EXISTS (SELECT 1 FROM LUDUSWebProperty WHERE propertyName = 'VDUP_KONFIGURATION') THEN
  INSERT INTO LUDUSWebProperty (propertyName, value)
  SELECT
    'VDUP_KONFIGURATION',
    '{"skolensInstNummer":"' || (SELECT institutionKode FROM SystemIndstillinger) ||
    '","wsURL":"https://vdup.dk/webservice/Edup_Service"}';
commit;
END IF;

IF NOT EXISTS ( SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'MobileNotification' AND cname = 'duDepositumPaaUddId') THEN
  ALTER TABLE MobileNotification  ADD duDepositumPaaUddId INTEGER NULL;
END IF;

IF NOT EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'MobileNotification' AND cname = 'depositumReference') THEN
  ALTER TABLE MobileNotification ADD depositumReference INTEGER NULL;
END IF;

IF NOT EXISTS ( SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'MobileNotification' AND cname = 'deadlineDato') THEN
  ALTER TABLE MobileNotification ADD deadlineDato DATE NULL;
END IF;

IF NOT EXISTS ( SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'MobileNotification' AND cname = 'antalDageTilDeadline') THEN
  ALTER TABLE MobileNotification ADD antalDageTilDeadline INTEGER NULL;
END IF;

IF NOT EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'MobileNotification' and role = 'duDepositumPaaUdd' ) THEN
  ALTER TABLE MobileNotification ADD CONSTRAINT duDepositumPaaUdd  FOREIGN KEY (duDepositumPaaUddId) REFERENCES DuBetaling(id) ON DELETE SET NULL;
END IF;

IF NOT EXISTS(select 1 from LUDUSWebProperty where propertyName = 'PDFUA_SERVICE_URL') 	THEN
    INSERT INTO LUDUSWebProperty (propertyName, value) VALUES ('PDFUA_SERVICE_URL', 'https://pdfua.svc.egdw.dk/docx2pdfua_packed');
	COMMIT;
END IF;

IF NOT EXISTS ( SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'MobileNotification' AND cname = 'webModultestForsoegId') THEN
  ALTER TABLE MobileNotification ADD webModultestForsoegId INTEGER NULL;
END IF;

IF NOT EXISTS ( SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'MobileNotification' AND cname = 'modultestReference') THEN
  ALTER TABLE MobileNotification ADD modultestReference INTEGER NULL;
END IF;

IF NOT EXISTS ( SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'MobileNotification' AND cname = 'modultestDato') THEN
  ALTER TABLE MobileNotification ADD modultestDato DATE NULL;
END IF;

IF NOT EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'MobileNotification' and role = 'fk_mobileNotif_webModultestForsoeg' ) THEN
  ALTER TABLE MobileNotification ADD CONSTRAINT fk_mobileNotif_webModultestForsoeg  FOREIGN KEY (webModultestForsoegId)  REFERENCES WebModultestForsoeg(id) ON DELETE SET NULL;
END IF;

QUIT;